﻿ALTER TABLE [dbo].[t_Borrower]
    ADD CONSTRAINT [CK_t_Borrower_SSN] CHECK ([SSN] like '[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]' OR isnull([SSN],'0')='0');


GO
ALTER TABLE [dbo].[t_Borrower] NOCHECK CONSTRAINT [CK_t_Borrower_SSN];

